![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Analysis ToolsSeveral analysis tools available from Oracle and third parties are useful in tracking down inefficiencies and bottlenecks in SQL statements. These tools work both on the client machines and on the server itself. These analysis tools can assist you in tracking down a particular SQL statement that is causing problems or can point to a particular table or cluster that is inefficient. Two of the Oracle toolsOracle Expert and Oracle Traceare part of the new Oracle Mission Control console. Oracle Mission Control is a graphical console designed to assist you in monitoring, managing, and tuning your Oracle systems. Oracle Expert is designed to look for and correct system bottlenecks. Oracle has recently introduced the Oracle Trace product, which originated with Digital RDB. Oracle Trace can be used in a manner similar to SQL Trace and can be extended to the network and applications. Third-party tools are also available to analyze SQL statements and performance; these include tools from Platinum Technologies, Precise Software Solutions, Compuware, Eventus, and BMC. The following sections look at some of the analysis tools currently available. Oracle Mission ControlOracles Mission Control console is a graphical management station that includes some of the following features:
Oracle Trace Oracle Trace is a new product based on technology acquired when Oracle purchased the RDB product from Digital Equipment Corporation. Oracle Trace take SQL Trace to client/server computing.
Oracle Trace begins where SQL Trace left off. The key feature of Oracle Trace is its ability to monitor applications and third-party tools using the SQL Trace function. Oracle Trace collects performance data on predefined events in the Oracle Server, SQL*Net, Oracle Forms, or any third-party application that has been written to take advantage of Oracle Trace. Oracle Trace provides information similar to the data you expect from SQL Trace:
By allowing you to define your own data to monitoras either an end user or an applications developerthis tool offers tremendous flexibility. Oracle Trace information can be viewed with the Oracle Mission Control console and will soon be available in third-party performance-monitoring tools. By tracing your application from the client, through the network, and to the server, performance bottlenecks can more easily be detected and removed. Third-Party ToolsA number of fine products are on the market today, designed to help you analyze your system, determine bottlenecks, and remove those bottlenecks. Some of these tools are general; others focus on a specific area. The following sections take a sampling of the various tools that serve different purposes.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |